
DECLARE
	@ejerfGuid uniqueidentifier,
	@postnrGuid uniqueidentifier,
	@addrTypeGuid uniqueidentifier
	
SET @ejerfGuid = (SELECT TOP 1 GUID FROM EBAS_EJERFORHOLD)
SET @postnrGuid = (SELECT GUID FROM EBAS_POST_NR WHERE POST_NR = '8000')
SET @addrTypeGuid = (SELECT GUID FROM EBAS_ADRESSE_TYPE WHERE TYPE = 'Firma')

INSERT INTO EBAS_ADRESSE (GUID, GADE, POST_NR_GUID, TELEFON, E_MAIL, EJER_GUID, ADRESSE_TYPE_GUID)
VALUES (NEWID(), 'Hans Broges Gade 2', @postnrGuid, '7010 5005', 'mba@henley.dk', @ejerfGuid, @addrTypeGuid)
GO
